Overview

Dataset Statistics

Number of Variables 11
Number of Rows 2.8846e+06
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 748.6 MB
Average Row Size in Memory 272.1 B
Variable Types
  • Numerical: 6
  • DateTime: 2
  • Categorical: 3

Dataset Insights

BIKE STANDS is skewed Skewed
NAME has a high cardinality: 109 distinct values High Cardinality
ADDRESS has a high cardinality: 109 distinct values High Cardinality
STATUS has constant value "Open" Constant
STATUS has constant length 4 Constant Length
LONGITUDE has 2884576 (100.0%) negatives Negatives

Variables


STATION ID

numerical

Approximate Distinct Count 109
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 44.0 MB
Mean 60.3303
Minimum 2
Maximum 117
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • STATION ID is skewed left (γ1 = -0.0353)

Quantile Statistics

Minimum 2
5-th Percentile 7
Q1 31
Median 61
Q3 91
95-th Percentile 112
Maximum 117
Range 115
IQR 60

Descriptive Statistics

Mean 60.3303
Standard Deviation 33.8648
Variance 1146.8271
Sum 1.7403e+08
Skewness -0.03532
Kurtosis -1.2204
Coefficient of Variation 0.5613

TIME

datetime

Distinct Count 26401.2853
Approximate Unique (%) 0.9%
Missing 0
Missing (%) 0.0%
Memory Size 22.0 MB
Minimum 2021-04-01 00:00:03
Maximum 2021-07-01 23:55:02

LAST UPDATED

datetime

Distinct Count 1.3091e+06
Approximate Unique (%) 45.4%
Missing 0
Missing (%) 0.0%
Memory Size 22.0 MB
Minimum 2021-03-31 23:49:35
Maximum 2021-07-01 23:54:05

NAME

categorical

Approximate Distinct Count 109
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 224.4 MB

Length

Mean 16.5596
Standard Deviation 4.7708
Median 16
Minimum 9
Maximum 33

Sample

1st row BLESSINGTON STREET
2nd row BLESSINGTON STREET
3rd row BLESSINGTON STREET
4th row BLESSINGTON STREET
5th row BLESSINGTON STREET

Letter

Count 42792288
Lowercase Letter 0
Space Separator 4207776
Uppercase Letter 42792288
Dash Punctuation 0
Decimal Number 0
  • The largest value (street) is over 5.11 times larger than the second largest value (road)

BIKE STANDS

numerical

Approximate Distinct Count 17
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 44.0 MB
Mean 32.1101
Minimum 16
Maximum 40
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • BIKE STANDS is skewed left (γ1 = -0.4316)

Quantile Statistics

Minimum 16
5-th Percentile 20
Q1 29
Median 30
Q3 40
95-th Percentile 40
Maximum 40
Range 24
IQR 11

Descriptive Statistics

Mean 32.1101
Standard Deviation 7.6486
Variance 58.5017
Sum 9.2624e+07
Skewness -0.4316
Kurtosis -1.1335
Coefficient of Variation 0.2382
  • BIKE STANDS is not normally distributed (p-value 5.6330650085768654e-18)

AVAILABLE BIKE STANDS

numerical

Approximate Distinct Count 41
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 44.0 MB
Mean 20.1284
Minimum 0
Maximum 40
Zeros 30786
Zeros (%) 1.1%
Negatives 0
Negatives (%) 0.0%
  • AVAILABLE BIKE STANDS is skewed right (γ1 = 0.0015)

Quantile Statistics

Minimum 0
5-th Percentile 5
Q1 14
Median 20
Q3 27
95-th Percentile 36
Maximum 40
Range 40
IQR 13

Descriptive Statistics

Mean 20.1284
Standard Deviation 9.306
Variance 86.6023
Sum 5.8062e+07
Skewness 0.001502
Kurtosis -0.6708
Coefficient of Variation 0.4623
  • AVAILABLE BIKE STANDS is not normally distributed (p-value 0.00011137979939290217)

AVAILABLE BIKES

numerical

Approximate Distinct Count 41
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 44.0 MB
Mean 11.8447
Minimum 0
Maximum 40
Zeros 90677
Zeros (%) 3.1%
Negatives 0
Negatives (%) 0.0%
  • AVAILABLE BIKES is skewed right (γ1 = 0.6326)

Quantile Statistics

Minimum 0
5-th Percentile 1
Q1 6
Median 11
Q3 16
95-th Percentile 26
Maximum 40
Range 40
IQR 10

Descriptive Statistics

Mean 11.8447
Standard Deviation 7.3748
Variance 54.3873
Sum 3.4167e+07
Skewness 0.6326
Kurtosis 0.2036
Coefficient of Variation 0.6226
  • AVAILABLE BIKES is not normally distributed (p-value 8.931380378646171e-06)
  • AVAILABLE BIKES has 29719 outliers

STATUS

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 189.8 MB

Length

Mean 4
Standard Deviation 0
Median 4
Minimum 4
Maximum 4

Sample

1st row Open
2nd row Open
3rd row Open
4th row Open
5th row Open

Letter

Count 11538304
Lowercase Letter 8653728
Space Separator 0
Uppercase Letter 2884576
Dash Punctuation 0
Decimal Number 0
  • STATUS has words of constant length

ADDRESS

categorical

Approximate Distinct Count 109
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 224.4 MB

Length

Mean 16.578
Standard Deviation 4.7628
Median 16
Minimum 9
Maximum 33

Sample

1st row Blessington Street
2nd row Blessington Street
3rd row Blessington Street
4th row Blessington Street
5th row Blessington Street

Letter

Count 42818752
Lowercase Letter 35699936
Space Separator 4207776
Uppercase Letter 7118816
Dash Punctuation 0
Decimal Number 0
  • The largest value (street) is over 5.22 times larger than the second largest value (road)

LATITUDE

numerical

Approximate Distinct Count 109
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 44.0 MB
Mean 53.3455
Minimum 53.3301
Maximum 53.36
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • LATITUDE is skewed right (γ1 = 0.0779)

Quantile Statistics

Minimum 53.3301
5-th Percentile 53.3337
Q1 53.3398
Median 53.3452
Q3 53.3509
95-th Percentile 53.3584
Maximum 53.36
Range 0.02988
IQR 0.01116

Descriptive Statistics

Mean 53.3455
Standard Deviation 0.007569
Variance 5.7286e-05
Sum 1.5388e+08
Skewness 0.07786
Kurtosis -0.7722
Coefficient of Variation 0.00014188
  • LATITUDE is not normally distributed (p-value 0.000522824097740891)

LONGITUDE

numerical

Approximate Distinct Count 109
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 44.0 MB
Mean -6.2645
Minimum -6.31
Maximum -6.2309
Zeros 0
Zeros (%) 0.0%
Negatives 2884576
Negatives (%) 100.0%
  • LONGITUDE is skewed left (γ1 = -0.4446)

Quantile Statistics

Minimum -6.31
5-th Percentile -6.2978
Q1 -6.2752
Median -6.2632
Q3 -6.2509
95-th Percentile -6.2372
Maximum -6.2309
Range 0.07916
IQR 0.02433

Descriptive Statistics

Mean -6.2645
Standard Deviation 0.01819
Variance 0.00033076
Sum -1.807e+07
Skewness -0.4446
Kurtosis -0.2628
Coefficient of Variation -0.002903
  • LONGITUDE is not normally distributed (p-value 0.008148134073034023)

Interactions

Correlations

Missing Values